<cfcomponent extends="assets.calgrants.com.Base">

	<cfscript>
        import assets.calgrants.com.bo.Student;
	</cfscript>
	
	<cffunction name="get" access="public" output="false" returntype="assets.calgrants.com.bo.Student">
		<cfargument name="Student_ID" type="numeric" required="true" />
		<cfscript>
			if (arguments.Student_ID gt 0) {
				local.loadArgs = {};
				local.loadArgs.obj = new Student();
				StructAppend(local.loadArgs, QueryToStruct(read(argumentCollection = arguments))[1]);
				return load(argumentCollection = local.loadArgs);
			} else {
				return new Student();
			}
		</cfscript>
	</cffunction>

	<cffunction name="load" access="public" output="false" returntype="assets.calgrants.com.bo.Student">
		<cfargument name="obj" type="assets.calgrants.com.bo.Student" required="true" />
		<cfscript>
			local.obj = arguments.obj;
			if (IsDefined("arguments.Student_ID")) {
				local.obj.setStudent_ID(arguments.Student_ID);
			}
			if (IsDefined("arguments.Deleted")) {
				local.obj.setDeleted(arguments.Deleted); 
			}
			if (IsDefined("arguments.Origin")) {
				local.obj.setOrigin(arguments.Origin); 
			}
			if (IsDefined("arguments.Workshop_ID")) {
				local.obj.setWorkshop_ID(arguments.Workshop_ID); 
			}
			if (IsDefined("arguments.Study_ID")) {
				local.obj.setStudy_ID(arguments.Study_ID); 
			}
			if (IsDefined("arguments.Consent_Type")) {
				local.obj.setConsent_Type(arguments.Consent_Type); 
			}
			if (IsDefined("arguments.Follow_Up_Status")) {
				local.obj.setFollow_Up_Status(arguments.Follow_Up_Status); 
			}
			if (IsDefined("arguments.Follow_Up_FAFSA")) {
				local.obj.setFollow_Up_FAFSA(arguments.Follow_Up_FAFSA); 
			}
			if (IsDefined("arguments.Follow_Up_CA_Dream_Act")) {
				local.obj.setFollow_Up_CA_Dream_Act(arguments.Follow_Up_CA_Dream_Act); 
			}
			if (IsDefined("arguments.Follow_Up_Taxes")) {
				local.obj.setFollow_Up_Taxes(arguments.Follow_Up_Taxes); 
			}
			if (IsDefined("arguments.Follow_Up_Income_Assets")) {
				local.obj.setFollow_Up_Income_Assets(arguments.Follow_Up_Income_Assets); 
			}
			if (IsDefined("arguments.Follow_Up_Cal_Grant_Deadline")) {
				local.obj.setFollow_Up_Cal_Grant_Deadline(arguments.Follow_Up_Cal_Grant_Deadline); 
			}
			if (IsDefined("arguments.Follow_Up_Cal_Grant_Requirements")) {
				local.obj.setFollow_Up_Cal_Grant_Requirements(arguments.Follow_Up_Cal_Grant_Requirements); 
			}
			if (IsDefined("arguments.Follow_Up_Other")) {
				local.obj.setFollow_Up_Other(arguments.Follow_Up_Other); 
			}
			if (IsDefined("arguments.Follow_Up_Notes")) {
				local.obj.setFollow_Up_Notes(arguments.Follow_Up_Notes); 
			}
			if (IsDefined("arguments.First_Name")) {
				local.obj.setFirst_Name(arguments.First_Name); 
			}
			if (IsDefined("arguments.Last_Name")) {
				local.obj.setLast_Name(arguments.Last_Name); 
			}
			if (IsDefined("arguments.Address")) {
				local.obj.setAddress(arguments.Address); 
			}
			if (IsDefined("arguments.City")) {
				local.obj.setCity(arguments.City); 
			}
			if (IsDefined("arguments.Zip_Code")) {
				local.obj.setZip_Code(arguments.Zip_Code); 
			}
			if (IsDefined("arguments.DOB")) {
				local.obj.setDOB(arguments.DOB); 
			}
			if (IsDefined("arguments.Phone1")) {
				local.obj.setPhone1(arguments.Phone1); 
			}
			if (IsDefined("arguments.Phone2")) {
				local.obj.setPhone2(arguments.Phone2); 
			}
			if (IsDefined("arguments.Email")) {
				local.obj.setEmail(arguments.Email); 
			}
			if (IsDefined("arguments.SSN_Code")) {
				local.obj.setSSN_Code(arguments.SSN_Code); 
			}
			if (IsDefined("arguments.SSN")) {
				local.obj.setSSN(arguments.SSN); 
			}
			if (IsDefined("arguments.First_Name_Alt1")) {
				local.obj.setFirst_Name_Alt1(arguments.First_Name_Alt1); 
			}
			if (IsDefined("arguments.Last_Name_Alt1")) {
				local.obj.setLast_Name_Alt1(arguments.Last_Name_Alt1); 
			}
			if (IsDefined("arguments.Address_Alt1")) {
				local.obj.setAddress_Alt1(arguments.Address_Alt1); 
			}
			if (IsDefined("arguments.City_Alt1")) {
				local.obj.setCity_Alt1(arguments.City_Alt1); 
			}
			if (IsDefined("arguments.Zip_Code_Alt1")) {
				local.obj.setZip_Code_Alt1(arguments.Zip_Code_Alt1); 
			}
			if (IsDefined("arguments.Phone_Alt1")) {
				local.obj.setPhone_Alt1(arguments.Phone_Alt1); 
			}
			if (IsDefined("arguments.Email_Alt1")) {
				local.obj.setEmail_Alt1(arguments.Email_Alt1); 
			}
			if (IsDefined("arguments.First_Name_Alt2")) {
				local.obj.setFirst_Name_Alt2(arguments.First_Name_Alt2); 
			}
			if (IsDefined("arguments.Last_Name_Alt2")) {
				local.obj.setLast_Name_Alt2(arguments.Last_Name_Alt2); 
			}
			if (IsDefined("arguments.Address_Alt2")) {
				local.obj.setAddress_Alt2(arguments.Address_Alt2); 
			}
			if (IsDefined("arguments.City_Alt2")) {
				local.obj.setCity_Alt2(arguments.City_Alt2); 
			}
			if (IsDefined("arguments.Zip_Code_Alt2")) {
				local.obj.setZip_Code_Alt2(arguments.Zip_Code_Alt2); 
			}
			if (IsDefined("arguments.Phone_Alt2")) {
				local.obj.setPhone_Alt2(arguments.Phone_Alt2); 
			}
			if (IsDefined("arguments.Email_Alt2")) {
				local.obj.setEmail_Alt2(arguments.Email_Alt2); 
			}
			if (IsDefined("arguments.Date_Created")) {
				local.obj.setDate_Created(arguments.Date_Created);
			}			
			return local.obj;
		</cfscript>
	</cffunction>

	<cffunction name="read" access="public" output="false" returntype="any">
		<cfargument name="Student_ID" required="false" default="" />
		<cfargument name="Origin" required="false" default="" />
		<cfargument name="Deleted" required="false" default="0" />
		<cfargument name="Workshop_ID" required="false" default="" />
		<cfargument name="Study_ID" required="false" default="" />
		<cfargument name="Consent_Type" required="false" default="" />
		<cfargument name="Follow_Up_Status" required="false" default="" />
		<cfargument name="Follow_Up_FAFSA" required="false" default="" />
		<cfargument name="Follow_Up_CA_Dream_Act" required="false" default="" />
		<cfargument name="Follow_Up_Taxes" required="false" default="" />
		<cfargument name="Follow_Up_Income_Assets" required="false" default="" />
		<cfargument name="Follow_Up_Cal_Grant_Deadline" required="false" default="" />
		<cfargument name="Follow_Up_Cal_Grant_Requirements" required="false" default="" />
		<cfargument name="Follow_Up_Other" required="false" default="" />
		<cfargument name="Follow_Up_Notes" required="false" default="" />
		<cfargument name="First_Name" required="false" default="" />
		<cfargument name="Last_Name" required="false" default="" />
		<cfargument name="Address" required="false" default="" />
		<cfargument name="City" required="false" default="" />
		<cfargument name="Zip_Code" required="false" default="" />
		<cfargument name="DOB" required="false" default="" />
		<cfargument name="Phone1" required="false" default="" />
		<cfargument name="Phone2" required="false" default="" />
		<cfargument name="Email" required="false" default="" />
		<cfargument name="SSN_Code" required="false" default="" />
		<cfargument name="SSN" required="false" default="" />
		<cfargument name="First_Name_Alt1" required="false" default="" />
		<cfargument name="Last_Name_Alt1" required="false" default="" />
		<cfargument name="Address_Alt1" required="false" default="" />
		<cfargument name="City_Alt1" required="false" default="" />
		<cfargument name="Zip_Code_Alt1" required="false" default="" />
		<cfargument name="Phone_Alt1" required="false" default="" />
		<cfargument name="Email_Alt1" required="false" default="" />
		<cfargument name="First_Name_Alt2" required="false" default="" />
		<cfargument name="Last_Name_Alt2" required="false" default="" />
		<cfargument name="Address_Alt2" required="false" default="" />
		<cfargument name="City_Alt2" required="false" default="" />
		<cfargument name="Zip_Code_Alt2" required="false" default="" />
		<cfargument name="Phone_Alt2" required="false" default="" />
		<cfargument name="Email_Alt2" required="false" default="" />
		<cfargument name="Date_Created" required="false" default="" />
		<cfargument name="programYears" required="false" default="" />
		<cfargument name="followUp" required="false" default="" />
		<cfargument name="studentIDs" required="false" default="" />
		<cfargument name="workshopIDs" required="false" default="" />
		<cfargument name="organizationIDs" required="false" default="" />
		<cfargument name="regionIDs" required="false" default="" />

		<cfset var recs = "">
		<cfstoredproc datasource="#getDatasource()#" procedure="readStudent">
			<cfprocparam value="#arguments.Student_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Student_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Origin#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Origin)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Deleted#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Deleted)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Workshop_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Workshop_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Study_ID#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Study_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Consent_Type#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Consent_Type)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_Status#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Follow_Up_Status)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_FAFSA#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Follow_Up_FAFSA)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_CA_Dream_Act#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Follow_Up_CA_Dream_Act)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_Taxes#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Follow_Up_Taxes)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_Income_Assets#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Follow_Up_Income_Assets)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_Cal_Grant_Deadline#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Follow_Up_Cal_Grant_Deadline)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_Cal_Grant_Requirements#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Follow_Up_Cal_Grant_Requirements)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_Other#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Follow_Up_Other)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Follow_Up_Notes#" cfsqltype="CF_SQL_LONGVARCHAR" null="#IIf(Len(Trim(arguments.Follow_Up_Notes)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.First_Name#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.First_Name)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Last_Name#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Last_Name)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Address#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Address)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.City#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.City)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Zip_Code#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Zip_Code)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.DOB#" cfsqltype="CF_SQL_TIMESTAMP" null="#IIf(Len(Trim(arguments.DOB)) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(arguments.Phone1)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Phone1)) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(arguments.Phone2)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Phone2)) eq 0, true, false)#" />
			<cfprocparam value="#LCase(arguments.Email)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Email)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.SSN_Code#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.SSN_Code)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.SSN#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.SSN)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.First_Name_Alt1#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.First_Name_Alt1)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Last_Name_Alt1#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Last_Name_Alt1)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Address_Alt1#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Address_Alt1)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.City_Alt1#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.City_Alt1)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Zip_Code_Alt1#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Zip_Code_Alt1)) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(arguments.Phone_Alt1)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Phone_Alt1)) eq 0, true, false)#" />
			<cfprocparam value="#LCase(arguments.Email_Alt1)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Email_Alt1)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.First_Name_Alt2#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.First_Name_Alt2)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Last_Name_Alt2#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Last_Name_Alt2)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Address_Alt2#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Address_Alt2)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.City_Alt2#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.City_Alt2)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Zip_Code_Alt2#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Zip_Code_Alt2)) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(arguments.Phone_Alt2)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Phone_Alt2)) eq 0, true, false)#" />
			<cfprocparam value="#LCase(arguments.Email_Alt2)#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Email_Alt2)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Date_Created#" cfsqltype="CF_SQL_TIMESTAMP" null="#IIf(Len(Trim(arguments.Date_Created)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.programYears#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.programYears)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.followUp#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.followUp), true, false)#" />
			<cfprocparam value="#arguments.studentIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.studentIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.workshopIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.workshopIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.organizationIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.organizationIDs)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.regionIDs#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.regionIDs)) eq 0, true, false)#" />
			<cfprocresult name="recs" />
		</cfstoredproc>
		<cfreturn recs />
	</cffunction>

	<cffunction name="save" access="public" output="false" returntype="any">
		<cfargument name="student" required="true" type="assets.calgrants.com.bo.Student" />

		<cfstoredproc datasource="#getDatasource()#" procedure="saveStudent">
			<cfprocparam value="#student.getStudent_ID()#" cfsqltype="CF_SQL_INTEGER" variable="id" type="inout" null="false" />
			<cfprocparam value="#student.getOrigin()#" cfsqltype="CF_SQL_VARCHAR" null="false" />
			<cfprocparam value="#student.getDeleted()#" cfsqltype="CF_SQL_BIT" null="false" />
			<cfprocparam value="#student.getWorkshop_ID()#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="#student.getStudy_ID()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getStudy_ID())) eq 0, true, false)#" />
			<cfprocparam value="#student.getConsent_Type()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getConsent_Type())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_Status()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getFollow_Up_Status())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_FAFSA()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(student.getFollow_Up_FAFSA())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_CA_Dream_Act()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(student.getFollow_Up_CA_Dream_Act())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_Taxes()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(student.getFollow_Up_Taxes())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_Income_Assets()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(student.getFollow_Up_Income_Assets())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_Cal_Grant_Deadline()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(student.getFollow_Up_Cal_Grant_Deadline())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_Cal_Grant_Requirements()#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(student.getFollow_Up_Cal_Grant_Requirements())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_Other()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getFollow_Up_Other())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFollow_Up_Notes()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getFollow_Up_Notes())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFirst_Name()#" cfsqltype="CF_SQL_VARCHAR" null="false" />
			<cfprocparam value="#student.getLast_Name()#" cfsqltype="CF_SQL_VARCHAR" null="false" />
			<cfprocparam value="#student.getAddress()#" cfsqltype="CF_SQL_VARCHAR" null="false" />
			<cfprocparam value="#student.getCity()#" cfsqltype="CF_SQL_VARCHAR" null="false" />
			<cfprocparam value="#student.getZip_Code()#" cfsqltype="CF_SQL_VARCHAR" null="false" />
			<cfprocparam value="#student.getDOB()#" cfsqltype="CF_SQL_TIMESTAMP" null="false" />
			<cfprocparam value="#formatPhone(student.getPhone1())#" cfsqltype="CF_SQL_VARCHAR"  null="#IIf(Len(Trim(student.getPhone1())) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(student.getPhone2())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getPhone2())) eq 0, true, false)#" />
			<cfprocparam value="#LCase(student.getEmail())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getEmail())) eq 0, true, false)#" />
			<cfprocparam value="#student.getSSN_Code()#" cfsqltype="CF_SQL_VARCHAR" null="false" />
			<cfprocparam value="#student.getSSN()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getSSN())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFirst_Name_Alt1()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getFirst_Name_Alt1())) eq 0, true, false)#" />
			<cfprocparam value="#student.getLast_Name_Alt1()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getLast_Name_Alt1())) eq 0, true, false)#" />
			<cfprocparam value="#student.getAddress_Alt1()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getAddress_Alt1())) eq 0, true, false)#" />
			<cfprocparam value="#student.getCity_Alt1()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getCity_Alt1())) eq 0, true, false)#" />
			<cfprocparam value="#student.getZip_Code_Alt1()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getZip_Code_Alt1())) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(student.getPhone_Alt1())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getPhone_Alt1())) eq 0, true, false)#" />
			<cfprocparam value="#LCase(student.getEmail_Alt1())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getEmail_Alt1())) eq 0, true, false)#" />
			<cfprocparam value="#student.getFirst_Name_Alt2()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getFirst_Name_Alt2())) eq 0, true, false)#" />
			<cfprocparam value="#student.getLast_Name_Alt2()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getLast_Name_Alt2())) eq 0, true, false)#" />
			<cfprocparam value="#student.getAddress_Alt2()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getAddress_Alt2())) eq 0, true, false)#" />
			<cfprocparam value="#student.getCity_Alt2()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getCity_Alt2())) eq 0, true, false)#" />
			<cfprocparam value="#student.getZip_Code_Alt2()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getZip_Code_Alt2())) eq 0, true, false)#" />
			<cfprocparam value="#formatPhone(student.getPhone_Alt2())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getPhone_Alt2())) eq 0, true, false)#" />
			<cfprocparam value="#LCase(student.getEmail_Alt2())#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(student.getEmail_Alt2())) eq 0, true, false)#" />
		</cfstoredproc>
		<cfreturn id />
	</cffunction>

	<cffunction name="destroy" access="public" output="false" returntype="any">
		<cfargument name="Student_ID" required="true" />

		<cfstoredproc datasource="#getDatasource()#" procedure="destroyStudent">
			<cfprocparam value="#arguments.Student_ID#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="true" cfsqltype="CF_SQL_BIT" null="false" />
		</cfstoredproc>
		<cfreturn true />
	</cffunction>

</cfcomponent>

